﻿update
    Tree
set 
    NodePath = replace(NodePath, OldParentPath, NewParentPath)
where
    NodePath LIKE OldParentPath + '%'
